load data
truncate                                       
into table CRST_PO_REQUISITION_LINES_ALL
fields terminated by "	"                      
trailing nullcols 
( REQUISITION_LINE_ID            ,
  REQUISITION_HEADER_ID          ,
  LINE_NUM                       ,
  LINE_TYPE_ID                   ,
  CATEGORY_ID                    ,
  ITEM_DESCRIPTION               ,
  UNIT_MEAS_LOOKUP_CODE          ,
  UNIT_PRICE                     ,
  QUANTITY                       ,
  DELIVER_TO_LOCATION_ID         ,
  TO_PERSON_ID                   ,
  LAST_UPDATE_DATE               Date "YYYYMMDD HH24:MI:SS",
  LAST_UPDATED_BY                ,
  SOURCE_TYPE_CODE               ,
  LAST_UPDATE_LOGIN              ,
  CREATION_DATE                  Date "YYYYMMDD HH24:MI:SS",
  CREATED_BY                     ,
  ITEM_ID                        ,
  ITEM_REVISION                  ,
  QUANTITY_DELIVERED             ,
  SUGGESTED_BUYER_ID             ,
  ENCUMBERED_FLAG                ,
  RFQ_REQUIRED_FLAG              ,
  NEED_BY_DATE                   Date "YYYYMMDD HH24:MI:SS",
  LINE_LOCATION_ID               ,
  MODIFIED_BY_AGENT_FLAG         ,
  PARENT_REQ_LINE_ID             ,
  JUSTIFICATION                  ,
  NOTE_TO_AGENT                  ,
  NOTE_TO_RECEIVER               ,
  PURCHASING_AGENT_ID            ,
  DOCUMENT_TYPE_CODE             ,
  BLANKET_PO_HEADER_ID           ,
  BLANKET_PO_LINE_NUM            ,
  CURRENCY_CODE                  ,
  RATE_TYPE                      ,
  RATE_DATE                      Date "YYYYMMDD HH24:MI:SS",
  RATE                           ,
  CURRENCY_UNIT_PRICE            ,
  SUGGESTED_VENDOR_NAME          ,
  SUGGESTED_VENDOR_LOCATION      ,
  SUGGESTED_VENDOR_CONTACT       ,
  SUGGESTED_VENDOR_PHONE         ,
  SUGGESTED_VENDOR_PRODUCT_CODE  ,
  UN_NUMBER_ID                   ,
  HAZARD_CLASS_ID                ,
  MUST_USE_SUGG_VENDOR_FLAG      ,
  REFERENCE_NUM                  ,
  ON_RFQ_FLAG                    ,
  URGENT_FLAG                    ,
  CANCEL_FLAG                    ,
  SOURCE_ORGANIZATION_ID         ,
  SOURCE_SUBINVENTORY            ,
  DESTINATION_TYPE_CODE          ,
  DESTINATION_ORGANIZATION_ID    ,
  DESTINATION_SUBINVENTORY       ,
  QUANTITY_CANCELLED             ,
  CANCEL_DATE                    Date "YYYYMMDD HH24:MI:SS",
  CANCEL_REASON                  ,
  CLOSED_CODE                    ,
  AGENT_RETURN_NOTE              ,
  CHANGED_AFTER_RESEARCH_FLAG    ,
  VENDOR_ID                      ,
  VENDOR_SITE_ID                 ,
  VENDOR_CONTACT_ID              ,
  RESEARCH_AGENT_ID              ,
  ON_LINE_FLAG                   ,
  WIP_ENTITY_ID                  ,
  WIP_LINE_ID                    ,
  WIP_REPETITIVE_SCHEDULE_ID     ,
  WIP_OPERATION_SEQ_NUM          ,
  WIP_RESOURCE_SEQ_NUM           ,
  ATTRIBUTE_CATEGORY             ,
  DESTINATION_CONTEXT            ,
  INVENTORY_SOURCE_CONTEXT       ,
  VENDOR_SOURCE_CONTEXT          ,
  ATTRIBUTE1                     ,
  ATTRIBUTE2                     ,
  ATTRIBUTE3                     ,
  ATTRIBUTE4                     ,
  ATTRIBUTE5                     ,
  ATTRIBUTE6                     ,
  ATTRIBUTE7                     ,
  ATTRIBUTE8                     ,
  ATTRIBUTE9                     ,
  ATTRIBUTE10                    ,
  ATTRIBUTE11                    ,
  ATTRIBUTE12                    ,
  ATTRIBUTE13                    ,
  ATTRIBUTE14                    ,
  ATTRIBUTE15                    ,
  BOM_RESOURCE_ID                ,
  REQUEST_ID                     ,
  PROGRAM_APPLICATION_ID         ,
  PROGRAM_ID                     ,
  PROGRAM_UPDATE_DATE            Date "YYYYMMDD HH24:MI:SS",
  USSGL_TRANSACTION_CODE         ,
  GOVERNMENT_CONTEXT             ,
  CLOSED_REASON                  ,
  CLOSED_DATE                    Date "YYYYMMDD HH24:MI:SS",
  TRANSACTION_REASON_CODE        ,
  QUANTITY_RECEIVED              ,
  SOURCE_REQ_LINE_ID             ,
  ORG_ID                         ,
  GLOBAL_ATTRIBUTE1              ,
  GLOBAL_ATTRIBUTE2              ,
  GLOBAL_ATTRIBUTE3              ,
  GLOBAL_ATTRIBUTE4              ,
  GLOBAL_ATTRIBUTE5              ,
  GLOBAL_ATTRIBUTE6              ,
  GLOBAL_ATTRIBUTE7              ,
  GLOBAL_ATTRIBUTE8              ,
  GLOBAL_ATTRIBUTE9              ,
  GLOBAL_ATTRIBUTE10             ,
  GLOBAL_ATTRIBUTE11             ,
  GLOBAL_ATTRIBUTE12             ,
  GLOBAL_ATTRIBUTE13             ,
  GLOBAL_ATTRIBUTE14             ,
  GLOBAL_ATTRIBUTE15             ,
  GLOBAL_ATTRIBUTE16             ,
  GLOBAL_ATTRIBUTE17             ,
  GLOBAL_ATTRIBUTE18             ,
  GLOBAL_ATTRIBUTE19             ,
  GLOBAL_ATTRIBUTE20             ,
  GLOBAL_ATTRIBUTE_CATEGORY      ,
  KANBAN_CARD_ID                 ,
  CATALOG_TYPE                   ,
  CATALOG_SOURCE                 ,
  MANUFACTURER_ID                ,
  MANUFACTURER_NAME              ,
  MANUFACTURER_PART_NUMBER       ,
  REQUESTER_EMAIL                ,
  REQUESTER_FAX                  ,
  REQUESTER_PHONE                ,
  UNSPSC_CODE                    ,
  OTHER_CATEGORY_CODE            ,
  SUPPLIER_DUNS                  ,
  TAX_STATUS_INDICATOR           ,
  PCARD_FLAG                     ,
  NEW_SUPPLIER_FLAG              ,
  AUTO_RECEIVE_FLAG              ,
  TAX_USER_OVERRIDE_FLAG         ,
  TAX_CODE_ID                    ,
  NOTE_TO_VENDOR                 ,
  OKE_CONTRACT_VERSION_ID        ,
  OKE_CONTRACT_HEADER_ID         ,
  ITEM_SOURCE_ID                 ,
  SUPPLIER_REF_NUMBER            ,
  SECONDARY_UNIT_OF_MEASURE      ,
  SECONDARY_QUANTITY             ,
  PREFERRED_GRADE                ,
  SECONDARY_QUANTITY_RECEIVED    ,
  SECONDARY_QUANTITY_CANCELLED   ,
  VMI_FLAG                       ,
  AUCTION_HEADER_ID              ,
  AUCTION_DISPLAY_NUMBER         ,
  AUCTION_LINE_NUMBER            ,
  REQS_IN_POOL_FLAG              ,
  BID_NUMBER                     ,
  BID_LINE_NUMBER                
)
